UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aP1AzHvEGzyGJKzfBnQUFpagBCM1OGh1Qcv28OJawqw='
WHERE
key_id = '9855667cf88e25a47565c35480ee750b268015f9e767a8c61f61dd4d92507a52'
AND (
token = 'aP1AzHvEGzyGJKzfBnQUFpagBCM1OGh1Qcv28OJawqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)