UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tuUtePJOJ4TXOZz+td6gJE5vcGjZlxAlGKDDMMem5Z8='
WHERE
key_id = 'f2168a32fdcf4ec74a89757e502e527466c35724d170ed809c9b2ef43cd11fed'
AND (
token = 'tuUtePJOJ4TXOZz+td6gJE5vcGjZlxAlGKDDMMem5Z8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)