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