UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8MuGFCDzL9GkIKqZLY55cT6S9zlaupUuUyOxj9ANf5U='
WHERE
key_id = 'ba4e56716eafd8fb145ef24ceda04090c7bfec75b5f4231d45d331106bcd14ec'
AND (
token = '8MuGFCDzL9GkIKqZLY55cT6S9zlaupUuUyOxj9ANf5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)