UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0dWBFDxrw/V1tY7FUGUni/szRG/M74ZEkLiW9Y8V4os='
WHERE
key_id = '57e4f15fe43a95d8c6a93ada473c862b651c63a52fc92081e581be84c2ef4b11'
AND (
token = '0dWBFDxrw/V1tY7FUGUni/szRG/M74ZEkLiW9Y8V4os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)