UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lIT1FFpR5Zw7Gq1dXFaNXaBb7VOWzrngeNsap81p/Ks='
WHERE
key_id = 'afe06cf22e951bd0186371cc28a204ac60b59653842a758406060468ef036460'
AND (
token = 'lIT1FFpR5Zw7Gq1dXFaNXaBb7VOWzrngeNsap81p/Ks='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)