UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gmY72rHn4PaY7ft5L/2upxp6Vdw/U2azbs1ndREvUp0='
WHERE
key_id = '9fb03205dcbcc70ef541fdb09e65265e335375d21e6af5cf7651723e8839d1f5'
AND (
token = 'gmY72rHn4PaY7ft5L/2upxp6Vdw/U2azbs1ndREvUp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)