UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HPWs5kU2xTmqaIPKW6Eh4Hv1Wt2Vu6g9PKmobjsM3fo='
WHERE
key_id = '7227298782bb288266c17847075f5f0a8e48d36bcf4b12a0d1147d60226e4756'
AND (
token = 'HPWs5kU2xTmqaIPKW6Eh4Hv1Wt2Vu6g9PKmobjsM3fo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)