UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H/7j5oIkKI8MgM1yD4bn5I83dfoWt1PHUnOwKIjO+v0='
WHERE
key_id = 'b0082b305145dc0c05cfe71d98d2a4d69f2b19ecc56f81a38421a2ab06b260c6'
AND (
token = 'H/7j5oIkKI8MgM1yD4bn5I83dfoWt1PHUnOwKIjO+v0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)