UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uTfmcN6JcnA7fW/m1GmydVj1eHC6E/lo8RGNu1jieek='
WHERE
key_id = 'ae15dba1c97e1feb6e303b604ac3c65a8467bbec09611e797b21adbbb31a131b'
AND (
token = 'uTfmcN6JcnA7fW/m1GmydVj1eHC6E/lo8RGNu1jieek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)