UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f9JkalHoSK/WstKuXfc7HYV4xzv6jTjviktYb6UIWGQ='
WHERE
key_id = '3c414fc4de40c4e138bc0d92da014cc102496cbe86db63cf068927ea63430b8a'
AND (
token = 'f9JkalHoSK/WstKuXfc7HYV4xzv6jTjviktYb6UIWGQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)