UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W4oAAEa2vDVJut2fBiqLbIs70ptabTJoD9pAEJpoCBA='
WHERE
key_id = 'c172cdffea17a7c000788ac88d6f25bd64e70206d978e9afa0851fd8e5438b13'
AND (
token = 'W4oAAEa2vDVJut2fBiqLbIs70ptabTJoD9pAEJpoCBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)