UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S9yxNb9vly/mA4QMmHErjiwjiYchKXPBImgguM3E5K4='
WHERE
key_id = 'fed25794f9b349b582835f6e23ac028b04bd8a5abc535f1fc0f1d5da287337f5'
AND (
token = 'S9yxNb9vly/mA4QMmHErjiwjiYchKXPBImgguM3E5K4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)