UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DqXX37MKyF9LAm4xyRcx9Rj7JYi8tm0mIwJS1GyAMVU='
WHERE
key_id = 'd56616fe05b022b0efb67100a0a89703a931aaaf6392839672b5a1602e8553f3'
AND (
token = 'DqXX37MKyF9LAm4xyRcx9Rj7JYi8tm0mIwJS1GyAMVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)