UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7fRqIcL2WICxmbO2Mnio6+vxyTxu3b3Xo3ilO+s5+No='
WHERE
key_id = '4e4c092829a6da6fb0cd4bc7277c2f8d8b2292b31c380cfe0a1b653b43d9a531'
AND (
token = '7fRqIcL2WICxmbO2Mnio6+vxyTxu3b3Xo3ilO+s5+No='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)