UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4Ls3bvL2EWn5qE2r6rAZmmFC9vvlFxuMV0ndvlmTclo='
WHERE
key_id = 'ef235495b528225b995c0ef3ad96bad0f4ace6f839874a0013c524da9ae51bb5'
AND (
token = '4Ls3bvL2EWn5qE2r6rAZmmFC9vvlFxuMV0ndvlmTclo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)