UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfv/ZN/keBTv254rVI1Q91f2XrrTTeNzCm98TSQJ0/4='
WHERE
key_id = '594c19aac9dfdbcb0f17d57a2f9605a371784b55ad871a8bdeaaf5b56e2e9df5'
AND (
token = 'pfv/ZN/keBTv254rVI1Q91f2XrrTTeNzCm98TSQJ0/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)