UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tPLg/dDsnvIzXXIFPU7hUtxDlt6rqmCmjB+f+W9Dg+8='
WHERE
key_id = '5b9d1eec9f323b5d3aaf1b949333fade7fd146ecb0fefed3b25eb7ee0ba16606'
AND (
token = 'tPLg/dDsnvIzXXIFPU7hUtxDlt6rqmCmjB+f+W9Dg+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)