UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mhoP4ZYHl2CFkbGSjJGrq3QW0nWolFZFK+R4Fj94enM='
WHERE
key_id = 'a34eef595196e0ea75534c1fdf14735d60bc92d018061da55d9054c2690ad3f0'
AND (
token = 'mhoP4ZYHl2CFkbGSjJGrq3QW0nWolFZFK+R4Fj94enM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)