UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X4nL4d8dLe7vmJREF83rapVSqUJFkOPb4PyRt4F7g/U='
WHERE
key_id = '00a022f36010422155fd50b030c4b0326bc020cdc5f4cdd13af04a5e51ce1985'
AND (
token = 'X4nL4d8dLe7vmJREF83rapVSqUJFkOPb4PyRt4F7g/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)