UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c2vGEEP2rmHj0EAPNZbuotR/ZHt2XoIZZehWvCYU1W8='
WHERE
key_id = '187076c43aff0f77889a9b50089cf66e8dc1049b20ed354d1c82b230180c05e0'
AND (
token = 'c2vGEEP2rmHj0EAPNZbuotR/ZHt2XoIZZehWvCYU1W8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)