UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p9p2BcxEHJTa8boo81NcXHPwqS/uyxJS7BV0WBIvRS8='
WHERE
key_id = '527e181422a167a5cfc733235a2ab19c25f68266cd06df746e4572feadc52384'
AND (
token = 'p9p2BcxEHJTa8boo81NcXHPwqS/uyxJS7BV0WBIvRS8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)