UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eH5Nykbg+jSkk0oJHeBBjmL/W3Ldjic0eMrplB9ImYo='
WHERE
key_id = '9bc85219156e8ce476829e469a23a53192a101882696f1710b53ba7bf966a399'
AND (
token = 'eH5Nykbg+jSkk0oJHeBBjmL/W3Ldjic0eMrplB9ImYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)