UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MID8b2vJkj70T4Odv2aOZAC+Xp8k9LB/+7T2Rhpnegk='
WHERE
key_id = '34cfc659216e6f794e982bfefac4598c11c8f007524a8c4df2f90ef7000042be'
AND (
token = 'MID8b2vJkj70T4Odv2aOZAC+Xp8k9LB/+7T2Rhpnegk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)