UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p7IGlSXDgFOQ5QQHAW0Qsp9mPWMZ6GrbkcxLrxTsDr0='
WHERE
key_id = '27d7c19a15b67ff0b6b2bfc1310d81601b455665c97d1c6676c6cb463068677e'
AND (
token = 'p7IGlSXDgFOQ5QQHAW0Qsp9mPWMZ6GrbkcxLrxTsDr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)