UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HnFD9e28FkgZxvOqBCpM6ueq5QVjCesVTvw07aP9LAM='
WHERE
key_id = '7528f40a005d181000b894c8f8191e56f9da508a4a307f4367657df0e8181f07'
AND (
token = 'HnFD9e28FkgZxvOqBCpM6ueq5QVjCesVTvw07aP9LAM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)