UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6tyXgLE1iP2hR+0zV8PcyRUY1GSiR1fFx/m5qtHTT+o='
WHERE
key_id = '21863d02909955d0c4f03ef0dc35a869727b86a3dba1a63acab218fd42be646a'
AND (
token = '6tyXgLE1iP2hR+0zV8PcyRUY1GSiR1fFx/m5qtHTT+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)