UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pFwG8V1mqDravZyOowd3EbvWD+TMBL4YHyQDgYx42yY='
WHERE
key_id = '42d8e6b37ffdbf37d4f672b96004ad0c892b8cdff380e9fa0b065b6acf13b81d'
AND (
token = 'pFwG8V1mqDravZyOowd3EbvWD+TMBL4YHyQDgYx42yY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)