UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lrsVpMMSdZkJllK8K6cCCtR0hOIlIk94s/S7cF+9nPc='
WHERE
key_id = '716c733a75b9c90cdbf88bff9ba4ab43080fb431e32f4dec0e78169991e65937'
AND (
token = 'lrsVpMMSdZkJllK8K6cCCtR0hOIlIk94s/S7cF+9nPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)