UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WEXFCoYyzj8XYxN7uQrSXiuzEwZcA+LnfC76r/FFlUo='
WHERE
key_id = '788ac144e0b13517891afb64a7c28e0f508a0d06f99dbab787c432b239a90edb'
AND (
token = 'WEXFCoYyzj8XYxN7uQrSXiuzEwZcA+LnfC76r/FFlUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)