UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qjDS86gHOYL77sO3NXPlzETuXbDhfxf3m9wErTYo4UI='
WHERE
key_id = 'eaf111155c5d8ca76c14ee4972a7ce00fc9e67f376d78c84770783f8408d1297'
AND (
token = 'qjDS86gHOYL77sO3NXPlzETuXbDhfxf3m9wErTYo4UI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)