UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GxOBYjl6nDT0zGMBh/N7SeMd6ZcB2Pl5jT5jz+haNhg='
WHERE
key_id = 'fd980665db765d654002339425a25f8e9e5a3895582f4f12d27219b749c6b5f3'
AND (
token = 'GxOBYjl6nDT0zGMBh/N7SeMd6ZcB2Pl5jT5jz+haNhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)