UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xY8EFCWi0ElYNJTm6UyzUrcBf2LmhcTuycAHmTt1c/k='
WHERE
key_id = '111891d3f570b0e8f498e85a0b469567d463bb490a51048193bd5140914a24f8'
AND (
token = 'xY8EFCWi0ElYNJTm6UyzUrcBf2LmhcTuycAHmTt1c/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)