UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BxXz55/xoaOYIhbaJo8PGPhLNvCaHx+KuKc4ERAGf20='
WHERE
key_id = '5a499e25fd8ec4ed114f8503eb24f0907fe2f1d06f4ac87d41b1d0aa71b971d8'
AND (
token = 'BxXz55/xoaOYIhbaJo8PGPhLNvCaHx+KuKc4ERAGf20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)