UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pzx2E4HQZ4ZI8p6rufYFN9iA6nFhaYasLzx7j2fZW4M='
WHERE
key_id = '82fa268a33f2e647f24f62759208a53ecb52f45c088e97aef344e7b8661cfc15'
AND (
token = 'pzx2E4HQZ4ZI8p6rufYFN9iA6nFhaYasLzx7j2fZW4M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)