UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qOJnS4O/fUijr3LEQEbjmLGPRTKToEJI+BH2YzBgtI8='
WHERE
key_id = 'c710bf31ee252713d0eb20693c470e1fad75a7e508ae80958bd7b648d2ba12b8'
AND (
token = 'qOJnS4O/fUijr3LEQEbjmLGPRTKToEJI+BH2YzBgtI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)