UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/myE11zpINUiD2Vvj58C/dbWnyv23VAJmrUHj83r+kU='
WHERE
key_id = '5f61569b0ba09110a8c5dd84c2028f32d2104f2df9a771e88a46e5850cd7a97d'
AND (
token = '/myE11zpINUiD2Vvj58C/dbWnyv23VAJmrUHj83r+kU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)